<?php
include("../share/config.php");

for($i=1;$i<6;$i++){
	$sql = "select count(*) from cr_info where building ='$i'";
	$result= mysqli_query($conn,$sql);
	$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
	echo "<div class='col-md-4 column'>";
	echo "<h2>教".$i."楼预约情况</h2>";
	echo "<p>教".$i."楼共".$row["count(*)"]."个教室开放预约。</p></div>";
}
?>
 